package com.wfx.mapper;

import com.wfx.entity.WxbOrderCount;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author zhu
 * @since 2021-01-25
 */
public interface WxbOrderCountMapper extends BaseMapper<WxbOrderCount> {

    @Select("SELECT date_format(createtime,'%Y-%m')as dat,sum(order_money) as count1 FROM wxb_order_count GROUP BY date_format(createtime,'%Y-%m')")

    List<Map> statOrderCuntPerMouth();

}
